﻿CREATE TABLE [dbo].[Attachment]
(
	[Id] INT NOT NULL PRIMARY KEY IDENTITY, 
    [Name] NVARCHAR(45) NOT NULL DEFAULT '', 
    [Link] NVARCHAR(255) NOT NULL DEFAULT '', 
    [TaskId] INT NOT NULL, 
    CONSTRAINT [FK_Attachment_Task_Id] FOREIGN KEY ([TaskId]) REFERENCES [Task]([Id])
)

GO

CREATE INDEX [IX_Attachment_TaskId] ON [dbo].[Attachment] ([TaskId])
